{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["README","Audit_List"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,0,3,6],[4,1,5,5],[20,1,21,5],[29,1,32,5]]}
[]
[null,"Clinical Audit Demographics"]
[null,"from Vision 3"]
[]
["Step 1:","Select an audit line within Clinical Audit to view patients in the Month tab. Right mouse click on any patient name and select \"Copy\" from context menu (example image shown below)"]
[]
[null,"Note: You may also copy names from Patient Groups - Work Group Lists"]
[]
["Step 2:","Paste the list of patients into the sheet named \"Audit_List\""]
[]
["Step 3:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Click (Step 3) the button below to compile the report, which will format the patient list and include the selected data"]
[]
[]
["Step 4:"]
[]
[]
[null,"Important Note:"]
[null,"Once the report has successfully compiled it will show the SaveAs dialog box"]
[null,"This will save a CSV file to a folder of your choosing, and then clear the Audit_List"]
[null,"If any Transferred Out patients are found, or those that show no data for an item, or a mobile number that includes alphabetical characters -  they will not be included in the upload data sheet and will be shown in a separate sheet(s) within this workbook for your reference."]
[]
[]
[]
[]
[null,"When opening this workbook for the first time:"]
[null,"Excel 2010+ - Please \"Enable Content\" if a security Warning is displayed"]
[]
[null,"Excel 2007 - Please enable both Macros... and Data Connections"]
[null,"Excel 2003 - Not supported"]
[]
[null,"Created: 12/01/2021",null,"Updated: 19/03/2021"]
[null,"Version: 1.5"]
[null,"Written by: Bradley Sieve"]
[]
[null,"Image example of Clinical Audit Month Tab > Copy patients"]

{"sheet":"Audit_List","index":1,"n_rows":1,"n_cols":4,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Patient Forename","Patient Surname","Date of Birth","NHS/H+C No."]